﻿CREATE VIEW [dbo].[Price_View]
AS
SELECT     dbo.Order_Tbl.OrderID, dbo.Country_Tbl.Country, dbo.Order_Tbl.FirstName, dbo.Order_Tbl.LastName, dbo.Order_Tbl.BoatType, 
                      dbo.Order_Tbl.BoatName, dbo.Order_Tbl.SailNumber, dbo.Order_Tbl.OrderDateCreated, dbo.OrderLineItem_Tbl.LineItem, 
                      dbo.QuoteSailType_Tbl.SailType, dbo.OrderLineItem_Tbl.TotalPrice, dbo.OrderLineItem_Tbl.DeliveryDate, dbo.Country_Tbl.Country AS Expr1
FROM         dbo.Order_Tbl INNER JOIN
                      dbo.OrderLineItem_Tbl ON dbo.Order_Tbl.OrderID = dbo.OrderLineItem_Tbl.OrderID INNER JOIN
                      dbo.GenSailType_Tbl ON dbo.OrderLineItem_Tbl.GenSailTypeID = dbo.GenSailType_Tbl.GenSailTypeID INNER JOIN
                      dbo.QuoteSailType_Tbl ON dbo.OrderLineItem_Tbl.QuoteSailTypeID = dbo.QuoteSailType_Tbl.QuoteSailTypeID INNER JOIN
                      dbo.Country_Tbl ON dbo.Order_Tbl.CountryID = dbo.Country_Tbl.CountryID